SUPPORT / SAMPLES & SAS NOTES
Problem Note 51109: Generating histogram MAMetadata in SAS® Customer Intelligence fails when you are using the SQL procedure
 |  |  |  |
You might encounter an error similar to the following in the SASCustIntelCore6.1.log when you are generating histogram MAMetadata:
ERROR 2013-07-25 14:46:40,291
MetadataSQLHistogramGenerator$NumericHistogramQueryGenerator TID[CIExec-11]
Exception running metadata query:
com.sas.iquery.dataretrieval.DataRetrievalException: Error while submitting SAS code
1 options Locale=en_US;
2 LIBNAME MAMeta ORACLE PATH=MAMeta SCHEMA=xxx USER=sasdemo
PASSWORD=XXX ;
Libname MAMeta
'D:\sas\ServerConfig\Lev1\Applications\SASCustomerIntelligence\CampaignManagement\Data\MAMeta';
7 libname MetaTMP
'D:\SAS\ServerConfig\Lev1\Applications\SASCustomerIntelligence\CampaignManagemen
t\Data\MAMORoot/AAGBBGLS2RF3SYHN';
8 /*root.Date Of Birth:Year:DATE_WITH_TIME:SUBJECT_ID_CUSTOMER*/
9
10 PROC SQL;
11 Create table MetaTMP.MAM_20600004EAECRC2S2JB3UYDP as
12 SELECT
13 (CASE WHEN ( ( table0.DATE_OF_BIRTH ) ) IS NULL THEN .
14 WHEN ( ( table0.DATE_OF_BIRTH ) ) <
'01Jan1001:00:00:00'dt THEN 1
ERROR: Invalid date/time/datetime constant '01Jan1001:00:00:00'dt.This error occurs when you are using PROC SQL as a method and the underlying data contains a date with ranges. You are able to generate histogram MAMetadata using the SUMMARY procedure.
This problem occurs because the code that generates the numeric histogram data was modified. To avoid this error, either use PROC SUMMARY as a method or use the new Extended Attribute on the date data item only:
ForceMetaGenType=SQL or ForceMetaGenType=Summary
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence Studio | Microsoft® Windows® for x64 | 6.1 | 6.3 | 9.4 TS1M0 | |
| Microsoft Windows 8 Enterprise x64 | 6.1 | 6.3 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Pro x64 | 6.1 | 6.3 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 R2 | 6.1 | 6.3 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 6.1 | 6.3 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Datacenter | 6.1 | 6.3 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Std | 6.1 | 6.3 | 9.4 TS1M0 | |||
| Windows 7 Enterprise x64 | 6.1 | 6.3 | 9.4 TS1M0 | |||
| Windows 7 Professional x64 | 6.1 | 6.3 | 9.4 TS1M0 | |||